Joint Venture Cash Flow Waterfall: Cumulative Distribution Hurdles   Excel template (XLSX)
$75.00

Joint Venture Cash Flow Waterfall: Cumulative Distribution Hurdles (Excel template (XLSX)) Preview Image Joint Venture Cash Flow Waterfall: Cumulative Distribution Hurdles (Excel template (XLSX)) Preview Image Joint Venture Cash Flow Waterfall: Cumulative Distribution Hurdles (Excel template (XLSX)) Preview Image Joint Venture Cash Flow Waterfall: Cumulative Distribution Hurdles (Excel template (XLSX)) Preview Image Joint Venture Cash Flow Waterfall: Cumulative Distribution Hurdles (Excel template (XLSX)) Preview Image Joint Venture Cash Flow Waterfall: Cumulative Distribution Hurdles (Excel template (XLSX)) Preview Image Log in to unlock full preview.
Loading preview images...
Arrow   Unlock all 7 preview images:   Login Register

Joint Venture Cash Flow Waterfall: Cumulative Distribution Hurdles (Excel XLSX)

Excel (XLSX)

$75.00
This template was crafted by a Financial Modeler, Accountant, & Consultant with over 10+ years of experience in developing Real Estate Underwriting tools. He has served 750+ clients, from small family offices to billion-dollar corporations.
Add to Cart
  


Immediate download
Fully editable Excel
Free lifetime updates

DESCRIPTION

This product (Joint Venture Cash Flow Waterfall: Cumulative Distribution Hurdles) is an Excel template (XLSX), which you can download immediately upon purchase.

This is a joint venture cash flow waterfall. The template is designed for the user to enter in distributable cash flow (contributions and distributions) per period and the math takes over from there based on defined hurdle rates and cash flow splits per hurdle.

These are often designed based on IRR hurdles, but for this, there is no IRR consideration. Rather, the cash flow distributions and promotional split rate to the GP is based on the cumulative cash flow that has been distributed to the LP. That defines when a hurdle has been met.

There are up to 6 hurdles that can be configured for up to 60 periods. The hurdles are based on the cumulative cash flow that has been distributed to the LP (limited partner/investor). If you are using this for an annual basis, simply delete any unused columns and the model will continue to work without issue.

A percentage for contributions is defined between the GP and LP for any cash outflows that happen across the periods. This logic is not easy to build, especially when automatically figuring out the right cash split when multiple hurdles are reached within the same period, meaning in period ‘x' you may split some of the cash 90/10 and then if the next hurdle is 80/20 and the 80/20 hurdle was beaten in that same period ‘x', then some cash is split at the next hurdle rate and so on.

There are many ways to utilize this logic. If you want to make it a hard preferred equity up until the first hurdle, simply enter 100%/0% until the initial investment is fully repaid, or you can structure the hurdle amounts however you want.

There are final exit IRR rates that will display for the LP and GP as well as some visualizations to make it more clear for how cash is split over time and when various hurdles are met.

The most common uses for such models are in real estate deals, oil and gas, as well as general business startups where the investor simply wants to base the amount of available cash flow they are owed to be based on meeting total cash returned requirements. This joint venture financial model is often easier to explain than IRR hurdle-based templates as well.

Got a question about the product? Email us at support@flevy.com or ask the author directly by using the "Ask the Author a Question" form. If you cannot view the preview above this document description, go here to view the large preview instead.

Source: Best Practices in Joint Venture Excel: Joint Venture Cash Flow Waterfall: Cumulative Distribution Hurdles Excel (XLSX) Spreadsheet, Jason Varner | SmartHelping


$75.00
This template was crafted by a Financial Modeler, Accountant, & Consultant with over 10+ years of experience in developing Real Estate Underwriting tools. He has served 750+ clients, from small family offices to billion-dollar corporations.
Add to Cart
  

ABOUT THE AUTHOR

Additional documents from author: 173

I graduated in 2011 with a Bachelors degree in Accounting. From there, I worked at a few small businesses doing financial reporting and some bookkeeping. After a few years of that, I started doing freelance financial consulting work on Elance and Upwork.

After over 400 jobs completed with a 100% success rate, I now run my own modeling/consulting practice and continue to build new financial models every few weeks. [read more]

Ask the Author a Question

Must be logged in

Did you know?
The average daily rate of a McKinsey consultant is $6,625 (not including expenses). The average price of a Flevy document is $65.
Bundle and save! You can save up to % with bundles!

View bundle(s)




Trusted by over 10,000+ Client Organizations
Since 2012, we have provided best practices to over 10,000 businesses and organizations of all sizes, from startups and small businesses to the Fortune 100, in over 130 countries.
AT&T GE Cisco Intel IBM Coke Dell Toyota HP Nike Samsung Microsoft Astrazeneca JP Morgan KPMG Walgreens Walmart 3M Kaiser Oracle SAP Google E&Y Volvo Bosch Merck Fedex Shell Amgen Eli Lilly Roche AIG Abbott Amazon PwC T-Mobile Broadcom Bayer Pearson Titleist ConEd Pfizer NTT Data Schwab




Read Customer Testimonials




Save with Bundles

This document is available as part of the following discounted bundle(s):


Your Recently Viewed Documents

Customers Also Bought These Documents


Customers Also Like These Documents

Related Management Topics


Joint Venture Cash Flow Management Alliances NPV Calculator Partnership Agreement Working Capital Management M&A (Mergers & Acquisitions)

Download our FREE Strategy & Transformation Framework Templates

Download our free compilation of 50+ Strategy & Transformation slides and templates. Frameworks include McKinsey 7-S, Balanced Scorecard, Disruptive Innovation, BCG Curve, and many more.